Chat with Jentech AI on WhatsApp

Data Analytics Course Outline

A structured, hands-on curriculum designed to build data analytics skills week by week.

Course Overview

Learn how to organize, analyze, and interpret data to uncover useful insights and support better decision-making. Students work with practical datasets from the beginning of the course, developing confidence in data handling, analysis, and reporting through hands-on tasks and real-world exercises before their final project.

Week 1: Data Setup & Understanding

  • The Data Ecosystem
  • The "Data Cleaning" Phase
  • Practice & Assessment

Week 2: Data Analysis with Excel

  • Formulas & Logic
  • Pivot Tables & Data Summarization
  • Practice & Assessment

Week 3: SQL for Data Queries

  • Introduction to SQL
  • Filtering & Aggregation
  • Practice & Assessment

Week 4: Visualization & Communication

  • Principles of Visualization
  • Building Interactive Dashboards
  • Insight Communication

Week 5: Mini Project

  • End-to-End Processing
  • Dashboard Build & Storyboarding
  • Final Presentation